UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QCH2Z+LnxqYbViU3qA0Pbype4uyZJo3xDVAq2Hu276A='
WHERE
key_id = 'a593b5f2c58cd3bd51e5ae4d4310a5f90e0d2ffb7578bfc3919b58c36aec3c0d'
AND (
token = 'QCH2Z+LnxqYbViU3qA0Pbype4uyZJo3xDVAq2Hu276A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)