UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r8HNl8Vc0zKJzNLGh64ztmrHqlPWuO4DnPET6UpWNcY='
WHERE
key_id = '3886f16c394f444c8502296497292af9c35ea00ea22c6a921467b364716055ad'
AND (
token = 'r8HNl8Vc0zKJzNLGh64ztmrHqlPWuO4DnPET6UpWNcY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)