UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PjPjppzlkSKpXx6stCWFgSOS4Rm4EDi1/0Lix9zGHBA='
WHERE
key_id = 'd1f5b9b9a87642167a9309a62bbbaddc289edc39f29f8d56af15651f80879a78'
AND (
token = 'PjPjppzlkSKpXx6stCWFgSOS4Rm4EDi1/0Lix9zGHBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)