UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GXMIhj8NhfzHcm3XFhwUuqgXbyhrVUE3OoidlnOHkAQ='
WHERE
key_id = 'bdde2a5d06ef01e137a74a190e3a58bbd0c35a46aa9f652b9dd56c9d934a4763'
AND (
token = 'GXMIhj8NhfzHcm3XFhwUuqgXbyhrVUE3OoidlnOHkAQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)