UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hkmtds22+y1hzVBsROU8qS4vL7S0eBmwD47MDwk75p8='
WHERE
key_id = 'bbf78c3653079f4b78a7ef8f2b4a3e573f5eb41472970c92da8e526346f59063'
AND (
token = 'Hkmtds22+y1hzVBsROU8qS4vL7S0eBmwD47MDwk75p8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)