UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd2n0V534+lmtYJfCK80yhXlkXtsKfnM8w4TKTvzVIX8='
WHERE
key_id = 'feb45bf1151d4aec0a55e1a24df57f007c87157cd1d9a70db615aae6b33f7265'
AND (
token = 'd2n0V534+lmtYJfCK80yhXlkXtsKfnM8w4TKTvzVIX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)