UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6LJAWQUFXQU7VnbC6ClEbr+bqWtX/yBboJjJn2xU32Q='
WHERE
key_id = 'abc585915a0f0db05640cd925a6bb3779bff3a89cf4703d35129fcdb2779ef4e'
AND (
token = '6LJAWQUFXQU7VnbC6ClEbr+bqWtX/yBboJjJn2xU32Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)