UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zhHgYjw5eYCw4hA9dMKGsZE7Z7cRj8mR+sN8SpXG7Jg='
WHERE
key_id = 'fb156a0b0c188c7c3cf0c7dc0951ce62abb69222b8a1469f169586e63dd164a2'
AND (
token = 'zhHgYjw5eYCw4hA9dMKGsZE7Z7cRj8mR+sN8SpXG7Jg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)