UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K8sEKXVdSu1gYrs+yZpDHK2nkuGObWABTm2h9iL6jhA='
WHERE
key_id = 'ea40b3d3314bed7f28b7215a64510bd44666195120a68fd4806b8f081ec7120f'
AND (
token = 'K8sEKXVdSu1gYrs+yZpDHK2nkuGObWABTm2h9iL6jhA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)