UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7XXK5oyYjwTlIG29QaxjkxSXhwKDDzdsuGN8BO8jUOo='
WHERE
key_id = '5bb4c3b5b1837cd3dcb72100a2f171db8e6fa7f9300c8483cb299412add3ceb0'
AND (
token = '7XXK5oyYjwTlIG29QaxjkxSXhwKDDzdsuGN8BO8jUOo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)