UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3vzhgW3HaE7xBABFoJp4RoU4jV1u2LDPqTD/NUd+JTU='
WHERE
key_id = '328718f6ae71358b341863fc8dd4932928e5b038b9c0fc025d7ca472b37843df'
AND (
token = '3vzhgW3HaE7xBABFoJp4RoU4jV1u2LDPqTD/NUd+JTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)