UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GiAsWqV6oYeqiot+NM4cu6rJu0Js4rD6AkIuk2OEuMg='
WHERE
key_id = 'ee5dc5ef1b8589e1724c2353fe0ed7870c7814e6f311b11630753d7a3f23b1a3'
AND (
token = 'GiAsWqV6oYeqiot+NM4cu6rJu0Js4rD6AkIuk2OEuMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)