UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YZyH5cmkOMBY7fsaQQ5eN4XOBjOShfh/8Qr7tFEWdqA='
WHERE
key_id = 'fe8240e5b5bc1605a40eef04c568327abb127dbde73ae5669f0bf16bf13ec9f5'
AND (
token = 'YZyH5cmkOMBY7fsaQQ5eN4XOBjOShfh/8Qr7tFEWdqA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)