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