UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jX/w5kaKlV10BdOqnfVgbgEFFin/vEs+yAN/6yvCUjQ='
WHERE
key_id = '769e527f42f5cc8b38133770e150f36cd719f092d2db820b02412a24f1f8f1d7'
AND (
token = 'jX/w5kaKlV10BdOqnfVgbgEFFin/vEs+yAN/6yvCUjQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)