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