UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '18BljGl8auThNFu1x/dYsqIVEnNF/dZjIzjeYvrDxS4='
WHERE
key_id = 'e2cd3789d99e9a1a5d9ba3dceaead8133b3700ab4b172cd90b063cc7da7403a3'
AND (
token = '18BljGl8auThNFu1x/dYsqIVEnNF/dZjIzjeYvrDxS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)