UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bk4BvVK/x4uPw1un6FH4SKzCbhKIzJMhoeLb4KlQdpk='
WHERE
key_id = 'a69f67de9bc6efdc90ea82b2e921ab43f530639ccb97f12509ff645b04dec100'
AND (
token = 'bk4BvVK/x4uPw1un6FH4SKzCbhKIzJMhoeLb4KlQdpk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)