UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sIAY4pMFL6GYpI/pZcBjUeRJjoSjiaun3qOOuKbhcEM='
WHERE
key_id = 'bb4f4a36e216388e7c32eb247d76984595eff919296a2c504473fbe378c97217'
AND (
token = 'sIAY4pMFL6GYpI/pZcBjUeRJjoSjiaun3qOOuKbhcEM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)