UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yJvRDqz4bC8QmNo6QdbqHtkSM7NL/tRE7e9tT/6O7Bw='
WHERE
key_id = 'f7dc1d00cd57bb07e4c6e8b1b11a1b16dab7dff3403b9224b1d2255a3b15e627'
AND (
token = 'yJvRDqz4bC8QmNo6QdbqHtkSM7NL/tRE7e9tT/6O7Bw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)