UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BB7maHLzR0TblnuSx4PDKWwZmShMMt1M9i7I+PKSzHE='
WHERE
key_id = '3ccf807c2ed5524b12f92bdd395341d49d1fea18345bf3c7fe277a29257b9bc9'
AND (
token = 'BB7maHLzR0TblnuSx4PDKWwZmShMMt1M9i7I+PKSzHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)