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