UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KFwKNvXYJ8AobhW1AswSEXI48RVm2VRvKE+/YJlJcOY='
WHERE
key_id = '4eb5235606eefe1ccf9dc729451568dd29641420237b504d1f592d855b6e8b14'
AND (
token = 'KFwKNvXYJ8AobhW1AswSEXI48RVm2VRvKE+/YJlJcOY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)