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