UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1sRh47iQGiI6MFqSYHfVWH0ggi5ex6irUIOPGIKvnrE='
WHERE
key_id = 'cdac636b410bb37c3f4776e198d0f00f98cf45df6b8cda13e1ac1d8312281fc6'
AND (
token = '1sRh47iQGiI6MFqSYHfVWH0ggi5ex6irUIOPGIKvnrE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)