UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CHmvOIwd10HlymHjQllO3Yrve87dCIC5/uyb+zdqTbw='
WHERE
key_id = 'a69a7a96bb3c4f5982ef956fe4bffa8800c2d1410da66e10978a43e9ee619eb9'
AND (
token = 'CHmvOIwd10HlymHjQllO3Yrve87dCIC5/uyb+zdqTbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)