UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pqSr6WPIDdBW88pBu1D6BAJeOdPkDeuIWvnfQr1NaVU='
WHERE
key_id = 'f17bce6af49e3b704f387a502756afece5eb70ec9525da500114efa07a4937b2'
AND (
token = 'pqSr6WPIDdBW88pBu1D6BAJeOdPkDeuIWvnfQr1NaVU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)