UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e5f/OS6GJuf16aQnqtiHHsXXkWoGwyJFomHE03PMWT4='
WHERE
key_id = 'c300b2464efc5b2701b387b81bbcd595c37bf4f5e623d5da4e3031a2d02a9ff9'
AND (
token = 'e5f/OS6GJuf16aQnqtiHHsXXkWoGwyJFomHE03PMWT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)