UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aEB2qiqOYhj76zliAOW9zrVP1LFvCb2HUbiN316I+hs='
WHERE
key_id = '7ab8432f8fef7e5d10442f712d343953e59c2cad26de2a96863b62154a8d9033'
AND (
token = 'aEB2qiqOYhj76zliAOW9zrVP1LFvCb2HUbiN316I+hs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)