UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Zr3CxczI6Dh52m5ZxZWrQDgFnQbzY8aifwBJvOcRSA='
WHERE
key_id = 'ffa13eaf0c7ab89e8867a064e5b576c11e69f28e8e82ea8869bb1b12c42d7bf4'
AND (
token = '7Zr3CxczI6Dh52m5ZxZWrQDgFnQbzY8aifwBJvOcRSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)