UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XX4xsUxkjOGnsqQvwX8zek+RhUVWlAaavRqM0duTapw='
WHERE
key_id = 'db0cd440fb1ed75999fb70c4e17eea0466b21dabe41fdbe94e9ff3fa33589e61'
AND (
token = 'XX4xsUxkjOGnsqQvwX8zek+RhUVWlAaavRqM0duTapw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)