UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q2q4h45D1l98tNhRNUA+1074d91FSVa8iOS59xSTR4M='
WHERE
key_id = '1c7429b1bbc2cb19997ed19dd18dbcec0936f01df18d5b1937ef13aa02c61c37'
AND (
token = 'q2q4h45D1l98tNhRNUA+1074d91FSVa8iOS59xSTR4M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)