UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AptnJjptW/nCsCIcMClRsReQMnzMlZHjoK3J+FPoMew='
WHERE
key_id = 'c246b08618ecdad5e7d434dca3d11d752b2f3cc65b1f04b450b7bfd9d45c0549'
AND (
token = 'AptnJjptW/nCsCIcMClRsReQMnzMlZHjoK3J+FPoMew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)