UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pO1hPCTD6dD08zBXOAcZIAL7d8TPcdjPDEved+NZ6vk='
WHERE
key_id = 'c3386eecc5aa4ae3553db92c20a5c39f5ef06c42c17cf031ff8df21a4d27118a'
AND (
token = 'pO1hPCTD6dD08zBXOAcZIAL7d8TPcdjPDEved+NZ6vk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)