UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i+1aX7WxXyefFk3DK/Hq/ZkHPvugcwSOIr8EQh3ives='
WHERE
key_id = '5947de6fcd3100a7155eca8302139d24c487130a61bcca5246d805a09c7404b4'
AND (
token = 'i+1aX7WxXyefFk3DK/Hq/ZkHPvugcwSOIr8EQh3ives='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)