UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EmrZte7hGrOKAO8MGhYgCd/cdQBkXTgy+i8p/7QimRo='
WHERE
key_id = 'bf10366d785c5e7e422154c2b5e633a991b3256820f0400a24c3e7138fa021f4'
AND (
token = 'EmrZte7hGrOKAO8MGhYgCd/cdQBkXTgy+i8p/7QimRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)